EMT Practice Test

1. Question Content...

---

Question1: You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT MONITOR technical user? Note: There are 2 correct answers to this question.

Question2: Where are the preinstalled SAP HANA mini-checks stored?

Question3: Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT?

Question4: Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit?

Question5: Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note: There are 2 correct answers to this question.

Question6: How are user group administrators and user groups related? Note: There are 2 correct answers to this question.

Question7: You want to implement a 28-day backup cycle. Which scenario uses the least storage?

Question8: What are the merge methods that are triggered by the SAP HANA system? Note: There are 2 correct answers to this question.

Question9: Which system privilege do you need to redistribute tables across the hosts in a scale-out system?

Question10: Which SAP HANA cockpit application can you use to investigate a system offline situation?

Question11: You are checking and monitoring SAP HANA system replication
Which status indicates a temporary connection loss of the secondary system?

Question12: Which prerequisites must be fulfilled to rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

Question13: Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.

Question14: You want to perform the database migration option (DMO) procedure.
Which components have to be updated if they are not on the right version level?
Note: There are 2 correct answers to this question.

Question15: Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question.

Question16: During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question.

Question17: You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime? Note: There are 2 correct answers to this question.

Question18: Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.

Question19: Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.

Question20: Which role do you need in order to assign users to groups in the SAP HANA cockpit?

Question21: How can you ensure that a consistent database status is saved using data snapshots?

Question22: Which database objects can manipulate if you have the Object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.

Question23: In a multitenant database container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?

Question24: Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

Question25: How does SAP HANA encrypt the data persistence layer?

Question26: What do need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.

Question27: Who owns an SAP HANA Deployment Infrastructure (HDI) role?

Question28: Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question.

Question29: You are planning an SAP S/4HANA scale-out system
What are the minimal size requirements for CPU and memory?

Question30: In which scenario do need SAP expert sizing? Note: There are 2 correct answers to this question.

Question31: What happens when you rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

Question32: Which system privileges are required for administrating tenant databases when connected to the system database? Note: There are 2 correct answers to this question.

Question33: How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.

Question34: The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question.

Question35: What is the recommended size for the log volume file system for a 512 GB SAP HANA database system?

Question36: What cryptographic libraries are supported in SAP HANA by default? Note: There are 2 correct answers to this question.

Question37: In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question.

Question38: Your customer has purchased a 3 TB SAP HANA license.
TO which value do you set the GLOBAL ALLOCATION LIMIT parameter when you have four 2 TB nodes in an SAP HANA scale-out system consisting of three worker and one standby nodes?

Question39: For an SAP HANA tailored datacenter integration (TDI) approach, what is the additional disk space factor required during delta merge operations?

Question40: Which actions take place during a database migration option (DMO) procedure when performing an in-place migration? Note: There are 2 correct answers to this question.

Question41: Which activities do you have to carry out to configure your multitenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)? Note: There are 3 correct answers to this question.